Overview
Brought to you by YData
Dataset statistics
| Number of variables | 25 |
|---|---|
| Number of observations | 2823 |
| Missing cells | 34473 |
| Missing cells (%) | 48.8% |
| Total size in memory | 551.5 KiB |
| Average record size in memory | 200.0 B |
Variable types
| Text | 17 |
|---|---|
| Numeric | 8 |
QUANTITYORDERED has 1315 (46.6%) missing values | Missing |
PRICEEACH has 1315 (46.6%) missing values | Missing |
ORDERLINENUMBER has 1315 (46.6%) missing values | Missing |
SALES has 1315 (46.6%) missing values | Missing |
ORDERDATE has 1315 (46.6%) missing values | Missing |
STATUS has 1315 (46.6%) missing values | Missing |
QTR_ID has 1315 (46.6%) missing values | Missing |
MONTH_ID has 1315 (46.6%) missing values | Missing |
YEAR_ID has 1315 (46.6%) missing values | Missing |
PRODUCTLINE has 1315 (46.6%) missing values | Missing |
MSRP has 1315 (46.6%) missing values | Missing |
PRODUCTCODE has 1315 (46.6%) missing values | Missing |
CUSTOMERNAME has 1315 (46.6%) missing values | Missing |
PHONE has 1315 (46.6%) missing values | Missing |
ADDRESSLINE1 has 1315 (46.6%) missing values | Missing |
ADDRESSLINE2 has 2684 (95.1%) missing values | Missing |
CITY has 1315 (46.6%) missing values | Missing |
STATE has 1784 (63.2%) missing values | Missing |
POSTALCODE has 1377 (48.8%) missing values | Missing |
COUNTRY has 1315 (46.6%) missing values | Missing |
TERRITORY has 2328 (82.5%) missing values | Missing |
CONTACTLASTNAME has 1315 (46.6%) missing values | Missing |
CONTACTFIRSTNAME has 1315 (46.6%) missing values | Missing |
DEALSIZE has 1315 (46.6%) missing values | Missing |
Reproduction
| Analysis started | 2025-11-10 21:23:52.691110 |
|---|---|
| Analysis finished | 2025-11-10 21:23:53.883268 |
| Duration | 1.19 second |
| Software version | ydata-profiling vv4.17.0 |
| Download configuration | config.json |
Variables
ORDERNUMBER
Text
| Distinct | 1480 |
|---|---|
| Distinct (%) | 52.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 22.2 KiB |
Length
| Max length | 233 |
|---|---|
| Median length | 5 |
| Mean length | 92.10556146 |
| Min length | 5 |
Unique
| Unique | 1321 ? |
|---|---|
| Unique (%) | 46.8% |
Sample
| 1st row | 10107 |
|---|---|
| 2nd row | 10121 |
| 3rd row | 10134 |
| 4th row | 10145 |
| 5th row | 10159 |
| Value | Count | Frequency (%) |
| 555 | 306 | 2.2% |
| moralzarzal | 259 | 1.8% |
| 94 | 259 | 1.8% |
| channel,(91 | 259 | 1.8% |
| shopping | 259 | 1.8% |
| 44,"c | 259 | 1.8% |
| and | 182 | 1.3% |
| rue | 153 | 1.1% |
| 86",,madrid,,28034,spain,emea,freyre,diego,medium | 131 | 0.9% |
| collectables | 124 | 0.9% |
| Other values (2997) | 11986 |
Most occurring characters
| Value | Count | Frequency (%) |
| , | 33073 | 12.7% |
| 0 | 18666 | 7.2% |
| 1 | 13716 | 5.3% |
| 2 | 11569 | 4.4% |
| 11402 | 4.4% | |
| e | 10675 | 4.1% |
| a | 10166 | 3.9% |
| 5 | 8334 | 3.2% |
| 4 | 8331 | 3.2% |
| i | 7988 | 3.1% |
| Other values (66) | 126094 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 91115 | |
| Decimal Number | 84922 | |
| Other Punctuation | 43793 | |
| Uppercase Letter | 25400 | 9.8% |
| Space Separator | 11402 | 4.4% |
| Connector Punctuation | 1315 | 0.5% |
| Dash Punctuation | 674 | 0.3% |
| Close Punctuation | 531 | 0.2% |
| Open Punctuation | 531 | 0.2% |
| Math Symbol | 289 | 0.1% |
| Other values (2) | 42 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 10675 | |
| a | 10166 | |
| i | 7988 | 8.8% |
| r | 7562 | 8.3% |
| n | 6616 | 7.3% |
| l | 6214 | 6.8% |
| o | 5725 | 6.3% |
| s | 5722 | 6.3% |
| d | 4385 | 4.8% |
| p | 4123 | 4.5% |
| Other values (16) | 21939 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 5163 | |
| C | 3386 | |
| M | 3080 | |
| E | 2525 | |
| A | 2441 | |
| L | 988 | 3.9% |
| F | 947 | 3.7% |
| D | 775 | 3.1% |
| P | 752 | 3.0% |
| T | 677 | 2.7% |
| Other values (14) | 4666 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 18666 | |
| 1 | 13716 | |
| 2 | 11569 | |
| 5 | 8334 | |
| 4 | 8331 | |
| 3 | 7221 | 8.5% |
| 8 | 4807 | 5.7% |
| 6 | 4534 | 5.3% |
| 9 | 4121 | 4.9% |
| 7 | 3623 | 4.3% |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 33073 | |
| . | 3175 | 7.3% |
| " | 2986 | 6.8% |
| / | 2979 | 6.8% |
| : | 1315 | 3.0% |
| ' | 174 | 0.4% |
| & | 59 | 0.1% |
| ¡ | 32 | 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 11402 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 1315 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 674 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 531 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 531 |
Math Symbol
| Value | Count | Frequency (%) |
| + | 289 |
Currency Symbol
| Value | Count | Frequency (%) |
| ¤ | 23 |
Control
| Value | Count | Frequency (%) |
| | 19 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 143499 | |
| Latin | 116515 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 10675 | 9.2% |
| a | 10166 | 8.7% |
| i | 7988 | 6.9% |
| r | 7562 | 6.5% |
| n | 6616 | 5.7% |
| l | 6214 | 5.3% |
| o | 5725 | 4.9% |
| s | 5722 | 4.9% |
| S | 5163 | 4.4% |
| d | 4385 | 3.8% |
| Other values (40) | 46299 |
Common
| Value | Count | Frequency (%) |
| , | 33073 | |
| 0 | 18666 | |
| 1 | 13716 | |
| 2 | 11569 | 8.1% |
| 11402 | 7.9% | |
| 5 | 8334 | 5.8% |
| 4 | 8331 | 5.8% |
| 3 | 7221 | 5.0% |
| 8 | 4807 | 3.3% |
| 6 | 4534 | 3.2% |
| Other values (16) | 21846 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 259940 | |
| None | 74 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| , | 33073 | 12.7% |
| 0 | 18666 | 7.2% |
| 1 | 13716 | 5.3% |
| 2 | 11569 | 4.5% |
| 11402 | 4.4% | |
| e | 10675 | 4.1% |
| a | 10166 | 3.9% |
| 5 | 8334 | 3.2% |
| 4 | 8331 | 3.2% |
| i | 7988 | 3.1% |
| Other values (63) | 126020 |
None
| Value | Count | Frequency (%) |
| ¡ | 32 | |
| ¤ | 23 | |
| | 19 |
QUANTITYORDERED
Real number (ℝ)
Missing
| Distinct | 56 |
|---|---|
| Distinct (%) | 3.7% |
| Missing | 1315 |
| Missing (%) | 46.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 35.13793103 |
| Minimum | 6 |
|---|---|
| Maximum | 85 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 22.2 KiB |
Quantile statistics
| Minimum | 6 |
|---|---|
| 5-th percentile | 21 |
| Q1 | 27 |
| median | 35 |
| Q3 | 43 |
| 95-th percentile | 49 |
| Maximum | 85 |
| Range | 79 |
| Interquartile range (IQR) | 16 |
Descriptive statistics
| Standard deviation | 9.730179021 |
|---|---|
| Coefficient of variation (CV) | 0.2769138288 |
| Kurtosis | 0.2701094943 |
| Mean | 35.13793103 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 0.3283178087 |
| Sum | 52988 |
| Variance | 94.67638377 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 34 | 60 | 2.1% |
| 48 | 60 | 2.1% |
| 27 | 58 | 2.1% |
| 36 | 57 | 2.0% |
| 26 | 55 | 1.9% |
| 31 | 55 | 1.9% |
| 33 | 54 | 1.9% |
| 46 | 52 | 1.8% |
| 29 | 52 | 1.8% |
| 25 | 52 | 1.8% |
| Other values (46) | 953 | |
| (Missing) | 1315 |
| Value | Count | Frequency (%) |
| 6 | 2 | |
| 10 | 2 | |
| 11 | 1 | |
| 12 | 1 | |
| 13 | 1 |
| Value | Count | Frequency (%) |
| 85 | 1 | |
| 77 | 1 | |
| 76 | 2 | |
| 70 | 1 | |
| 66 | 1 |
PRICEEACH
Real number (ℝ)
Missing
| Distinct | 633 |
|---|---|
| Distinct (%) | 42.0% |
| Missing | 1315 |
| Missing (%) | 46.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 83.95025862 |
| Minimum | 27.22 |
|---|---|
| Maximum | 100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 22.2 KiB |
Quantile statistics
| Minimum | 27.22 |
|---|---|
| 5-th percentile | 42.26 |
| Q1 | 69.87 |
| median | 96.7 |
| Q3 | 100 |
| 95-th percentile | 100 |
| Maximum | 100 |
| Range | 72.78 |
| Interquartile range (IQR) | 30.13 |
Descriptive statistics
| Standard deviation | 20.12215198 |
|---|---|
| Coefficient of variation (CV) | 0.2396913637 |
| Kurtosis | -0.2399313702 |
| Mean | 83.95025862 |
| Median Absolute Deviation (MAD) | 3.3 |
| Skewness | -0.9936937114 |
| Sum | 126596.99 |
| Variance | 404.9010001 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 100 | 708 | |
| 90.57 | 4 | 0.1% |
| 51.93 | 4 | 0.1% |
| 53.72 | 4 | 0.1% |
| 33.23 | 4 | 0.1% |
| 89.38 | 4 | 0.1% |
| 64 | 4 | 0.1% |
| 61.99 | 3 | 0.1% |
| 88.63 | 3 | 0.1% |
| 76.43 | 3 | 0.1% |
| Other values (623) | 767 | |
| (Missing) | 1315 |
| Value | Count | Frequency (%) |
| 27.22 | 1 | < 0.1% |
| 28.29 | 1 | < 0.1% |
| 28.88 | 1 | < 0.1% |
| 29.54 | 3 | |
| 29.7 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 100 | 708 | |
| 99.91 | 1 | < 0.1% |
| 99.66 | 1 | < 0.1% |
| 99.58 | 1 | < 0.1% |
| 99.55 | 2 | 0.1% |
ORDERLINENUMBER
Real number (ℝ)
Missing
| Distinct | 18 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 1315 |
| Missing (%) | 46.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.429708223 |
| Minimum | 1 |
|---|---|
| Maximum | 18 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 22.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 6 |
| Q3 | 9 |
| 95-th percentile | 14 |
| Maximum | 18 |
| Range | 17 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 4.230388145 |
|---|---|
| Coefficient of variation (CV) | 0.6579440308 |
| Kurtosis | -0.5547808912 |
| Mean | 6.429708223 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.6049765433 |
| Sum | 9696 |
| Variance | 17.89618386 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 165 | 5.8% |
| 2 | 159 | 5.6% |
| 3 | 147 | 5.2% |
| 4 | 138 | 4.9% |
| 5 | 127 | 4.5% |
| 6 | 117 | 4.1% |
| 7 | 105 | 3.7% |
| 8 | 100 | 3.5% |
| 9 | 86 | 3.0% |
| 10 | 73 | 2.6% |
| Other values (8) | 291 | 10.3% |
| (Missing) | 1315 |
| Value | Count | Frequency (%) |
| 1 | 165 | |
| 2 | 159 | |
| 3 | 147 | |
| 4 | 138 | |
| 5 | 127 |
| Value | Count | Frequency (%) |
| 18 | 6 | 0.2% |
| 17 | 11 | 0.4% |
| 16 | 23 | |
| 15 | 30 | |
| 14 | 46 |
SALES
Real number (ℝ)
Missing
| Distinct | 1490 |
|---|---|
| Distinct (%) | 98.8% |
| Missing | 1315 |
| Missing (%) | 46.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3568.921194 |
| Minimum | 541.14 |
|---|---|
| Maximum | 14082.8 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 22.2 KiB |
Quantile statistics
| Minimum | 541.14 |
|---|---|
| 5-th percentile | 1263.731 |
| Q1 | 2216.58 |
| median | 3194.395 |
| Q3 | 4508.27 |
| 95-th percentile | 7164.107 |
| Maximum | 14082.8 |
| Range | 13541.66 |
| Interquartile range (IQR) | 2291.69 |
Descriptive statistics
| Standard deviation | 1847.735232 |
|---|---|
| Coefficient of variation (CV) | 0.5177293449 |
| Kurtosis | 1.859279439 |
| Mean | 3568.921194 |
| Median Absolute Deviation (MAD) | 1094.285 |
| Skewness | 1.168804506 |
| Sum | 5381933.16 |
| Variance | 3414125.486 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2624 | 2 | 0.1% |
| 3451 | 2 | 0.1% |
| 3003 | 2 | 0.1% |
| 5464.69 | 2 | 0.1% |
| 3734 | 2 | 0.1% |
| 3508.8 | 2 | 0.1% |
| 2803.2 | 2 | 0.1% |
| 2688 | 2 | 0.1% |
| 1459.6 | 2 | 0.1% |
| 3789.72 | 2 | 0.1% |
| Other values (1480) | 1488 | |
| (Missing) | 1315 |
| Value | Count | Frequency (%) |
| 541.14 | 1 | |
| 577.6 | 1 | |
| 640.05 | 1 | |
| 651.8 | 1 | |
| 717.4 | 1 |
| Value | Count | Frequency (%) |
| 14082.8 | 1 | |
| 12536.5 | 1 | |
| 11623.7 | 1 | |
| 11336.7 | 1 | |
| 11279.2 | 1 |
ORDERDATE
Text
Missing
| Distinct | 146 |
|---|---|
| Distinct (%) | 9.7% |
| Missing | 1315 |
| Missing (%) | 46.6% |
| Memory size | 22.2 KiB |
Length
| Max length | 15 |
|---|---|
| Median length | 14 |
| Mean length | 14.01061008 |
| Min length | 13 |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | 0.2% |
Sample
| 1st row | 2/24/2003 0:00 |
|---|---|
| 2nd row | 5/7/2003 0:00 |
| 3rd row | 7/1/2003 0:00 |
| 4th row | 8/25/2003 0:00 |
| 5th row | 10/10/2003 0:00 |
| Value | Count | Frequency (%) |
| 0:00 | 1508 | |
| 11/4/2004 | 29 | 1.0% |
| 11/5/2003 | 28 | 0.9% |
| 9/8/2004 | 26 | 0.9% |
| 10/22/2004 | 26 | 0.9% |
| 11/5/2004 | 23 | 0.8% |
| 2/17/2005 | 22 | 0.7% |
| 10/15/2004 | 22 | 0.7% |
| 7/21/2004 | 20 | 0.7% |
| 10/10/2003 | 19 | 0.6% |
| Other values (137) | 1293 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 7912 | |
| / | 3016 | 14.3% |
| 2 | 2289 | 10.8% |
| 1 | 1660 | 7.9% |
| 1508 | 7.1% | |
| : | 1508 | 7.1% |
| 4 | 931 | 4.4% |
| 3 | 845 | 4.0% |
| 5 | 565 | 2.7% |
| 8 | 271 | 1.3% |
| Other values (3) | 623 | 2.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 15096 | |
| Other Punctuation | 4524 | 21.4% |
| Space Separator | 1508 | 7.1% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 7912 | |
| 2 | 2289 | 15.2% |
| 1 | 1660 | 11.0% |
| 4 | 931 | 6.2% |
| 3 | 845 | 5.6% |
| 5 | 565 | 3.7% |
| 8 | 271 | 1.8% |
| 7 | 261 | 1.7% |
| 9 | 200 | 1.3% |
| 6 | 162 | 1.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 3016 | |
| : | 1508 |
Space Separator
| Value | Count | Frequency (%) |
| 1508 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 21128 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 7912 | |
| / | 3016 | 14.3% |
| 2 | 2289 | 10.8% |
| 1 | 1660 | 7.9% |
| 1508 | 7.1% | |
| : | 1508 | 7.1% |
| 4 | 931 | 4.4% |
| 3 | 845 | 4.0% |
| 5 | 565 | 2.7% |
| 8 | 271 | 1.3% |
| Other values (3) | 623 | 2.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 21128 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 7912 | |
| / | 3016 | 14.3% |
| 2 | 2289 | 10.8% |
| 1 | 1660 | 7.9% |
| 1508 | 7.1% | |
| : | 1508 | 7.1% |
| 4 | 931 | 4.4% |
| 3 | 845 | 4.0% |
| 5 | 565 | 2.7% |
| 8 | 271 | 1.3% |
| Other values (3) | 623 | 2.9% |
STATUS
Text
Missing
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 1315 |
| Missing (%) | 46.6% |
| Memory size | 22.2 KiB |
Length
| Max length | 10 |
|---|---|
| Median length | 7 |
| Mean length | 7.078912467 |
| Min length | 7 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Shipped |
|---|---|
| 2nd row | Shipped |
| 3rd row | Shipped |
| 4th row | Shipped |
| 5th row | Shipped |
| Value | Count | Frequency (%) |
| shipped | 1399 | |
| on | 38 | 2.4% |
| hold | 38 | 2.4% |
| cancelled | 30 | 1.9% |
| resolved | 29 | 1.9% |
| in | 9 | 0.6% |
| process | 9 | 0.6% |
| disputed | 3 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| p | 2801 | |
| e | 1529 | |
| d | 1499 | |
| i | 1402 | |
| S | 1399 | |
| h | 1399 | |
| l | 127 | 1.2% |
| n | 77 | 0.7% |
| o | 76 | 0.7% |
| s | 50 | 0.5% |
| Other values (14) | 316 | 3.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 9073 | |
| Uppercase Letter | 1555 | 14.6% |
| Space Separator | 47 | 0.4% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| p | 2801 | |
| e | 1529 | |
| d | 1499 | |
| i | 1402 | |
| h | 1399 | |
| l | 127 | 1.4% |
| n | 77 | 0.8% |
| o | 76 | 0.8% |
| s | 50 | 0.6% |
| c | 39 | 0.4% |
| Other values (5) | 74 | 0.8% |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 1399 | |
| O | 38 | 2.4% |
| H | 38 | 2.4% |
| C | 30 | 1.9% |
| R | 29 | 1.9% |
| I | 9 | 0.6% |
| P | 9 | 0.6% |
| D | 3 | 0.2% |
Space Separator
| Value | Count | Frequency (%) |
| 47 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 10628 | |
| Common | 47 | 0.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| p | 2801 | |
| e | 1529 | |
| d | 1499 | |
| i | 1402 | |
| S | 1399 | |
| h | 1399 | |
| l | 127 | 1.2% |
| n | 77 | 0.7% |
| o | 76 | 0.7% |
| s | 50 | 0.5% |
| Other values (13) | 269 | 2.5% |
Common
| Value | Count | Frequency (%) |
| 47 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 10675 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| p | 2801 | |
| e | 1529 | |
| d | 1499 | |
| i | 1402 | |
| S | 1399 | |
| h | 1399 | |
| l | 127 | 1.2% |
| n | 77 | 0.7% |
| o | 76 | 0.7% |
| s | 50 | 0.5% |
| Other values (14) | 316 | 3.0% |
QTR_ID
Real number (ℝ)
Missing
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 1315 |
| Missing (%) | 46.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.777851459 |
| Minimum | 1 |
|---|---|
| Maximum | 4 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 22.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 4 |
| Maximum | 4 |
| Range | 3 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.176122835 |
|---|---|
| Coefficient of variation (CV) | 0.42339299 |
| Kurtosis | -1.393850796 |
| Mean | 2.777851459 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -0.3492826553 |
| Sum | 4189 |
| Variance | 1.383264923 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4 | 591 | |
| 1 | 321 | 11.4% |
| 3 | 312 | 11.1% |
| 2 | 284 | 10.1% |
| (Missing) | 1315 |
| Value | Count | Frequency (%) |
| 1 | 321 | |
| 2 | 284 | |
| 3 | 312 | |
| 4 | 591 |
| Value | Count | Frequency (%) |
| 4 | 591 | |
| 3 | 312 | |
| 2 | 284 | |
| 1 | 321 |
MONTH_ID
Real number (ℝ)
Missing
| Distinct | 12 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 1315 |
| Missing (%) | 46.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.305702918 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 22.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| median | 8 |
| Q3 | 11 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 7 |
Descriptive statistics
| Standard deviation | 3.502588952 |
|---|---|
| Coefficient of variation (CV) | 0.479432163 |
| Kurtosis | -1.289794045 |
| Mean | 7.305702918 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.3210388187 |
| Sum | 11017 |
| Variance | 12.26812937 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 11 | 314 | 11.1% |
| 10 | 173 | 6.1% |
| 3 | 133 | 4.7% |
| 5 | 132 | 4.7% |
| 8 | 129 | 4.6% |
| 2 | 111 | 3.9% |
| 12 | 104 | 3.7% |
| 7 | 102 | 3.6% |
| 9 | 81 | 2.9% |
| 4 | 80 | 2.8% |
| Other values (2) | 149 | 5.3% |
| (Missing) | 1315 |
| Value | Count | Frequency (%) |
| 1 | 77 | |
| 2 | 111 | |
| 3 | 133 | |
| 4 | 80 | |
| 5 | 132 |
| Value | Count | Frequency (%) |
| 12 | 104 | 3.7% |
| 11 | 314 | |
| 10 | 173 | |
| 9 | 81 | 2.9% |
| 8 | 129 |
YEAR_ID
Real number (ℝ)
Missing
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 1315 |
| Missing (%) | 46.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2003.801724 |
| Minimum | 2003 |
|---|---|
| Maximum | 2005 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 22.2 KiB |
Quantile statistics
| Minimum | 2003 |
|---|---|
| 5-th percentile | 2003 |
| Q1 | 2003 |
| median | 2004 |
| Q3 | 2004 |
| 95-th percentile | 2005 |
| Maximum | 2005 |
| Range | 2 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.6987122088 |
|---|---|
| Coefficient of variation (CV) | 0.0003486932865 |
| Kurtosis | -0.9419750236 |
| Mean | 2003.801724 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.2929233986 |
| Sum | 3021733 |
| Variance | 0.4881987507 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2004 | 713 | |
| 2003 | 547 | |
| 2005 | 248 | 8.8% |
| (Missing) | 1315 |
| Value | Count | Frequency (%) |
| 2003 | 547 | |
| 2004 | 713 | |
| 2005 | 248 | 8.8% |
| Value | Count | Frequency (%) |
| 2005 | 248 | 8.8% |
| 2004 | 713 | |
| 2003 | 547 |
PRODUCTLINE
Text
Missing
| Distinct | 7 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 1315 |
| Missing (%) | 46.6% |
| Memory size | 22.2 KiB |
Length
| Max length | 16 |
|---|---|
| Median length | 12 |
| Mean length | 10.8938992 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Motorcycles |
|---|---|
| 2nd row | Motorcycles |
| 3rd row | Motorcycles |
| 4th row | Motorcycles |
| 5th row | Motorcycles |
| Value | Count | Frequency (%) |
| cars | 821 | |
| classic | 485 | |
| vintage | 336 | |
| motorcycles | 187 | 7.0% |
| trucks | 165 | 6.2% |
| and | 165 | 6.2% |
| buses | 165 | 6.2% |
| planes | 164 | 6.2% |
| ships | 131 | 4.9% |
| trains | 40 | 1.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| s | 2808 | |
| a | 2011 | |
| C | 1306 | 7.9% |
| r | 1213 | 7.4% |
| 1151 | 7.0% | |
| c | 1024 | 6.2% |
| i | 992 | 6.0% |
| e | 852 | 5.2% |
| l | 836 | 5.1% |
| n | 705 | 4.3% |
| Other values (15) | 3530 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 12783 | |
| Uppercase Letter | 2494 | 15.2% |
| Space Separator | 1151 | 7.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| s | 2808 | |
| a | 2011 | |
| r | 1213 | |
| c | 1024 | 8.0% |
| i | 992 | 7.8% |
| e | 852 | 6.7% |
| l | 836 | 6.5% |
| n | 705 | 5.5% |
| t | 523 | 4.1% |
| o | 374 | 2.9% |
| Other values (7) | 1445 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 1306 | |
| V | 336 | 13.5% |
| T | 205 | 8.2% |
| M | 187 | 7.5% |
| B | 165 | 6.6% |
| P | 164 | 6.6% |
| S | 131 | 5.3% |
Space Separator
| Value | Count | Frequency (%) |
| 1151 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 15277 | |
| Common | 1151 | 7.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| s | 2808 | |
| a | 2011 | |
| C | 1306 | |
| r | 1213 | |
| c | 1024 | 6.7% |
| i | 992 | 6.5% |
| e | 852 | 5.6% |
| l | 836 | 5.5% |
| n | 705 | 4.6% |
| t | 523 | 3.4% |
| Other values (14) | 3007 |
Common
| Value | Count | Frequency (%) |
| 1151 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 16428 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| s | 2808 | |
| a | 2011 | |
| C | 1306 | 7.9% |
| r | 1213 | 7.4% |
| 1151 | 7.0% | |
| c | 1024 | 6.2% |
| i | 992 | 6.0% |
| e | 852 | 5.2% |
| l | 836 | 5.1% |
| n | 705 | 4.3% |
| Other values (15) | 3530 |
MSRP
Real number (ℝ)
Missing
| Distinct | 80 |
|---|---|
| Distinct (%) | 5.3% |
| Missing | 1315 |
| Missing (%) | 46.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 101.1047745 |
| Minimum | 33 |
|---|---|
| Maximum | 214 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 22.2 KiB |
Quantile statistics
| Minimum | 33 |
|---|---|
| 5-th percentile | 43 |
| Q1 | 68 |
| median | 99 |
| Q3 | 124 |
| 95-th percentile | 170 |
| Maximum | 214 |
| Range | 181 |
| Interquartile range (IQR) | 56 |
Descriptive statistics
| Standard deviation | 40.0180736 |
|---|---|
| Coefficient of variation (CV) | 0.3958079506 |
| Kurtosis | -0.05987990995 |
| Mean | 101.1047745 |
| Median Absolute Deviation (MAD) | 28 |
| Skewness | 0.5918132432 |
| Sum | 152466 |
| Variance | 1601.446215 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 99 | 59 | 2.1% |
| 118 | 58 | 2.1% |
| 136 | 48 | 1.7% |
| 62 | 41 | 1.5% |
| 60 | 41 | 1.5% |
| 68 | 40 | 1.4% |
| 80 | 33 | 1.2% |
| 86 | 31 | 1.1% |
| 102 | 30 | 1.1% |
| 54 | 30 | 1.1% |
| Other values (70) | 1097 | |
| (Missing) | 1315 |
| Value | Count | Frequency (%) |
| 33 | 13 | |
| 35 | 15 | |
| 37 | 12 | |
| 40 | 12 | |
| 41 | 13 |
| Value | Count | Frequency (%) |
| 214 | 16 | |
| 207 | 16 | |
| 194 | 11 | |
| 193 | 15 | |
| 173 | 16 |
PRODUCTCODE
Text
Missing
| Distinct | 109 |
|---|---|
| Distinct (%) | 7.2% |
| Missing | 1315 |
| Missing (%) | 46.6% |
| Memory size | 22.2 KiB |
Length
| Max length | 9 |
|---|---|
| Median length | 8 |
| Mean length | 8.115384615 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | S10_1678 |
|---|---|
| 2nd row | S10_1678 |
| 3rd row | S10_1678 |
| 4th row | S10_1678 |
| 5th row | S10_1678 |
| Value | Count | Frequency (%) |
| s18_3232 | 21 | 1.4% |
| s12_2823 | 18 | 1.2% |
| s18_3320 | 18 | 1.2% |
| s18_2957 | 18 | 1.2% |
| s10_4757 | 18 | 1.2% |
| s24_4258 | 18 | 1.2% |
| s18_3136 | 17 | 1.1% |
| s32_1268 | 17 | 1.1% |
| s700_1938 | 17 | 1.1% |
| s12_3891 | 16 | 1.1% |
| Other values (99) | 1330 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 1691 | |
| 1 | 1538 | |
| _ | 1508 | |
| S | 1508 | |
| 4 | 1067 | |
| 8 | 1064 | |
| 0 | 991 | |
| 3 | 900 | |
| 7 | 575 | 4.7% |
| 9 | 504 | 4.1% |
| Other values (2) | 892 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 9222 | |
| Connector Punctuation | 1508 | 12.3% |
| Uppercase Letter | 1508 | 12.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 1691 | |
| 1 | 1538 | |
| 4 | 1067 | |
| 8 | 1064 | |
| 0 | 991 | |
| 3 | 900 | |
| 7 | 575 | 6.2% |
| 9 | 504 | 5.5% |
| 6 | 493 | 5.3% |
| 5 | 399 | 4.3% |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 1508 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 1508 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 10730 | |
| Latin | 1508 | 12.3% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 1691 | |
| 1 | 1538 | |
| _ | 1508 | |
| 4 | 1067 | |
| 8 | 1064 | |
| 0 | 991 | |
| 3 | 900 | |
| 7 | 575 | 5.4% |
| 9 | 504 | 4.7% |
| 6 | 493 | 4.6% |
Latin
| Value | Count | Frequency (%) |
| S | 1508 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 12238 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 1691 | |
| 1 | 1538 | |
| _ | 1508 | |
| S | 1508 | |
| 4 | 1067 | |
| 8 | 1064 | |
| 0 | 991 | |
| 3 | 900 | |
| 7 | 575 | 4.7% |
| 9 | 504 | 4.1% |
| Other values (2) | 892 |
CUSTOMERNAME
Text
Missing
| Distinct | 51 |
|---|---|
| Distinct (%) | 3.4% |
| Missing | 1315 |
| Missing (%) | 46.6% |
| Memory size | 22.2 KiB |
Length
| Max length | 30 |
|---|---|
| Median length | 25 |
| Mean length | 20.55371353 |
| Min length | 10 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Land of Toys Inc. |
|---|---|
| 2nd row | Reims Collectables |
| 3rd row | Lyon Souveniers |
| 4th row | Toys4GrownUps.com |
| 5th row | Corporate Gift Ideas Co. |
| Value | Count | Frequency (%) |
| mini | 349 | 7.8% |
| inc | 335 | 7.4% |
| gifts | 304 | 6.8% |
| co | 263 | 5.8% |
| ltd | 230 | 5.1% |
| collectables | 210 | 4.7% |
| distributors | 203 | 4.5% |
| gift | 174 | 3.9% |
| ideas | 98 | 2.2% |
| diecast | 83 | 1.8% |
| Other values (72) | 2248 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2989 | 9.6% | |
| i | 2712 | 8.7% |
| s | 2345 | 7.6% |
| e | 2119 | 6.8% |
| t | 2092 | 6.7% |
| o | 1898 | 6.1% |
| n | 1668 | 5.4% |
| a | 1524 | 4.9% |
| l | 1383 | 4.5% |
| c | 1242 | 4.0% |
| Other values (42) | 11023 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 22349 | |
| Uppercase Letter | 4539 | 14.6% |
| Space Separator | 2989 | 9.6% |
| Other Punctuation | 1054 | 3.4% |
| Decimal Number | 56 | 0.2% |
| Dash Punctuation | 8 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| i | 2712 | |
| s | 2345 | |
| e | 2119 | |
| t | 2092 | |
| o | 1898 | |
| n | 1668 | 7.5% |
| a | 1524 | 6.8% |
| l | 1383 | 6.2% |
| c | 1242 | 5.6% |
| r | 1180 | 5.3% |
| Other values (15) | 4186 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 819 | |
| M | 562 | |
| G | 560 | |
| I | 527 | |
| L | 382 | |
| D | 372 | |
| S | 366 | |
| T | 177 | 3.9% |
| A | 146 | 3.2% |
| W | 125 | 2.8% |
| Other values (11) | 503 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 897 | |
| & | 91 | 8.6% |
| ' | 66 | 6.3% |
Space Separator
| Value | Count | Frequency (%) |
| 2989 |
Decimal Number
| Value | Count | Frequency (%) |
| 4 | 56 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 8 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 26888 | |
| Common | 4107 | 13.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| i | 2712 | 10.1% |
| s | 2345 | 8.7% |
| e | 2119 | 7.9% |
| t | 2092 | 7.8% |
| o | 1898 | 7.1% |
| n | 1668 | 6.2% |
| a | 1524 | 5.7% |
| l | 1383 | 5.1% |
| c | 1242 | 4.6% |
| r | 1180 | 4.4% |
| Other values (36) | 8725 |
Common
| Value | Count | Frequency (%) |
| 2989 | ||
| . | 897 | 21.8% |
| & | 91 | 2.2% |
| ' | 66 | 1.6% |
| 4 | 56 | 1.4% |
| - | 8 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 30995 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2989 | 9.6% | |
| i | 2712 | 8.7% |
| s | 2345 | 7.6% |
| e | 2119 | 6.8% |
| t | 2092 | 6.7% |
| o | 1898 | 6.1% |
| n | 1668 | 5.4% |
| a | 1524 | 4.9% |
| l | 1383 | 4.5% |
| c | 1242 | 4.0% |
| Other values (42) | 11023 |
PHONE
Text
Missing
| Distinct | 50 |
|---|---|
| Distinct (%) | 3.3% |
| Missing | 1315 |
| Missing (%) | 46.6% |
| Memory size | 22.2 KiB |
Length
| Max length | 16 |
|---|---|
| Median length | 10 |
| Mean length | 10.47214854 |
| Min length | 9 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2125557818 |
|---|---|
| 2nd row | 26.47.1555 |
| 3rd row | +33 1 46 62 7555 |
| 4th row | 6265557265 |
| 5th row | 6505551386 |
| Value | Count | Frequency (%) |
| 4155551450 | 180 | 8.8% |
| 3555 | 63 | 3.1% |
| 6175558555 | 51 | 2.5% |
| 2125557818 | 49 | 2.4% |
| 2125557413 | 48 | 2.3% |
| 035-640555 | 48 | 2.3% |
| 6505551386 | 41 | 2.0% |
| 26.47.1555 | 41 | 2.0% |
| 4085553659 | 40 | 1.9% |
| 6562-9555 | 40 | 1.9% |
| Other values (59) | 1453 |
Most occurring characters
| Value | Count | Frequency (%) |
| 5 | 6379 | |
| 1 | 1362 | 8.6% |
| 6 | 1089 | 6.9% |
| 2 | 1063 | 6.7% |
| 0 | 1012 | 6.4% |
| 4 | 972 | 6.2% |
| 8 | 811 | 5.1% |
| 7 | 708 | 4.5% |
| 3 | 680 | 4.3% |
| 546 | 3.5% | |
| Other values (6) | 1170 | 7.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 14544 | |
| Space Separator | 546 | 3.5% |
| Dash Punctuation | 308 | 2.0% |
| Other Punctuation | 122 | 0.8% |
| Open Punctuation | 95 | 0.6% |
| Close Punctuation | 95 | 0.6% |
| Math Symbol | 82 | 0.5% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 5 | 6379 | |
| 1 | 1362 | 9.4% |
| 6 | 1089 | 7.5% |
| 2 | 1063 | 7.3% |
| 0 | 1012 | 7.0% |
| 4 | 972 | 6.7% |
| 8 | 811 | 5.6% |
| 7 | 708 | 4.9% |
| 3 | 680 | 4.7% |
| 9 | 468 | 3.2% |
Space Separator
| Value | Count | Frequency (%) |
| 546 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 308 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 122 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 95 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 95 |
Math Symbol
| Value | Count | Frequency (%) |
| + | 82 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 15792 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 5 | 6379 | |
| 1 | 1362 | 8.6% |
| 6 | 1089 | 6.9% |
| 2 | 1063 | 6.7% |
| 0 | 1012 | 6.4% |
| 4 | 972 | 6.2% |
| 8 | 811 | 5.1% |
| 7 | 708 | 4.5% |
| 3 | 680 | 4.3% |
| 546 | 3.5% | |
| Other values (6) | 1170 | 7.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 15792 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 5 | 6379 | |
| 1 | 1362 | 8.6% |
| 6 | 1089 | 6.9% |
| 2 | 1063 | 6.7% |
| 0 | 1012 | 6.4% |
| 4 | 972 | 6.2% |
| 8 | 811 | 5.1% |
| 7 | 708 | 4.5% |
| 3 | 680 | 4.3% |
| 546 | 3.5% | |
| Other values (6) | 1170 | 7.4% |
ADDRESSLINE1
Text
Missing
| Distinct | 51 |
|---|---|
| Distinct (%) | 3.4% |
| Missing | 1315 |
| Missing (%) | 46.6% |
| Memory size | 22.2 KiB |
Length
| Max length | 42 |
|---|---|
| Median length | 24 |
| Mean length | 18.48806366 |
| Min length | 11 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 897 Long Airport Avenue |
|---|---|
| 2nd row | 59 rue de l'Abbaye |
| 3rd row | 27 rue du Colonel Pierre Avia |
| 4th row | 78934 Hillside Dr. |
| 5th row | 7734 Strong St. |
| Value | Count | Frequency (%) |
| st | 372 | 7.3% |
| strong | 250 | 4.9% |
| 5677 | 180 | 3.5% |
| circle | 135 | 2.6% |
| furth | 135 | 2.6% |
| dr | 133 | 2.6% |
| rue | 128 | 2.5% |
| street | 126 | 2.5% |
| avenue | 83 | 1.6% |
| ln | 83 | 1.6% |
| Other values (105) | 3476 |
Most occurring characters
| Value | Count | Frequency (%) |
| 3593 | 12.9% | |
| e | 1874 | 6.7% |
| t | 1680 | 6.0% |
| r | 1633 | 5.9% |
| n | 1386 | 5.0% |
| o | 1322 | 4.7% |
| i | 996 | 3.6% |
| a | 984 | 3.5% |
| S | 975 | 3.5% |
| l | 930 | 3.3% |
| Other values (47) | 12507 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 14835 | |
| Decimal Number | 5137 | 18.4% |
| Space Separator | 3593 | 12.9% |
| Uppercase Letter | 3346 | 12.0% |
| Other Punctuation | 836 | 3.0% |
| Dash Punctuation | 133 | 0.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 1874 | |
| t | 1680 | |
| r | 1633 | |
| n | 1386 | |
| o | 1322 | |
| i | 996 | 6.7% |
| a | 984 | 6.6% |
| l | 930 | 6.3% |
| g | 713 | 4.8% |
| u | 563 | 3.8% |
| Other values (11) | 2754 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 975 | |
| A | 308 | 9.2% |
| L | 292 | 8.7% |
| C | 269 | 8.0% |
| P | 211 | 6.3% |
| D | 183 | 5.5% |
| F | 161 | 4.8% |
| V | 146 | 4.4% |
| M | 121 | 3.6% |
| R | 107 | 3.2% |
| Other values (10) | 573 |
Decimal Number
| Value | Count | Frequency (%) |
| 7 | 874 | |
| 5 | 713 | |
| 4 | 552 | |
| 3 | 529 | |
| 6 | 507 | |
| 2 | 486 | |
| 8 | 443 | |
| 1 | 358 | |
| 9 | 353 | |
| 0 | 322 | 6.3% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 695 | |
| ' | 77 | 9.2% |
| ? | 38 | 4.5% |
| # | 26 | 3.1% |
Space Separator
| Value | Count | Frequency (%) |
| 3593 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 133 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 18181 | |
| Common | 9699 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 1874 | 10.3% |
| t | 1680 | 9.2% |
| r | 1633 | 9.0% |
| n | 1386 | 7.6% |
| o | 1322 | 7.3% |
| i | 996 | 5.5% |
| a | 984 | 5.4% |
| S | 975 | 5.4% |
| l | 930 | 5.1% |
| g | 713 | 3.9% |
| Other values (31) | 5688 |
Common
| Value | Count | Frequency (%) |
| 3593 | ||
| 7 | 874 | 9.0% |
| 5 | 713 | 7.4% |
| . | 695 | 7.2% |
| 4 | 552 | 5.7% |
| 3 | 529 | 5.5% |
| 6 | 507 | 5.2% |
| 2 | 486 | 5.0% |
| 8 | 443 | 4.6% |
| 1 | 358 | 3.7% |
| Other values (6) | 949 | 9.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 27880 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 3593 | 12.9% | |
| e | 1874 | 6.7% |
| t | 1680 | 6.0% |
| r | 1633 | 5.9% |
| n | 1386 | 5.0% |
| o | 1322 | 4.7% |
| i | 996 | 3.6% |
| a | 984 | 3.5% |
| S | 975 | 3.5% |
| l | 930 | 3.3% |
| Other values (47) | 12507 |
ADDRESSLINE2
Text
Missing
| Distinct | 5 |
|---|---|
| Distinct (%) | 3.6% |
| Missing | 2684 |
| Missing (%) | 95.1% |
| Memory size | 22.2 KiB |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 9 |
| Min length | 9 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Suite 101 |
|---|---|
| 2nd row | Suite 750 |
| 3rd row | Suite 101 |
| 4th row | Suite 750 |
| 5th row | 2nd Floor |
| Value | Count | Frequency (%) |
| suite | 103 | |
| 400 | 48 | |
| 2nd | 36 | 12.9% |
| floor | 36 | 12.9% |
| 101 | 25 | 9.0% |
| 750 | 20 | 7.2% |
| 200 | 10 | 3.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 161 | |
| 139 | ||
| u | 103 | 8.2% |
| S | 103 | 8.2% |
| t | 103 | 8.2% |
| i | 103 | 8.2% |
| e | 103 | 8.2% |
| o | 72 | 5.8% |
| 1 | 50 | 4.0% |
| 4 | 48 | 3.8% |
| Other values (8) | 266 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 628 | |
| Decimal Number | 345 | |
| Space Separator | 139 | 11.1% |
| Uppercase Letter | 139 | 11.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| u | 103 | |
| t | 103 | |
| i | 103 | |
| e | 103 | |
| o | 72 | |
| n | 36 | 5.7% |
| d | 36 | 5.7% |
| l | 36 | 5.7% |
| r | 36 | 5.7% |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 161 | |
| 1 | 50 | 14.5% |
| 4 | 48 | 13.9% |
| 2 | 46 | 13.3% |
| 7 | 20 | 5.8% |
| 5 | 20 | 5.8% |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 103 | |
| F | 36 | 25.9% |
Space Separator
| Value | Count | Frequency (%) |
| 139 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 767 | |
| Common | 484 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| u | 103 | |
| S | 103 | |
| t | 103 | |
| i | 103 | |
| e | 103 | |
| o | 72 | |
| n | 36 | 4.7% |
| F | 36 | 4.7% |
| d | 36 | 4.7% |
| l | 36 | 4.7% |
Common
| Value | Count | Frequency (%) |
| 0 | 161 | |
| 139 | ||
| 1 | 50 | 10.3% |
| 4 | 48 | 9.9% |
| 2 | 46 | 9.5% |
| 7 | 20 | 4.1% |
| 5 | 20 | 4.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1251 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 161 | |
| 139 | ||
| u | 103 | 8.2% |
| S | 103 | 8.2% |
| t | 103 | 8.2% |
| i | 103 | 8.2% |
| e | 103 | 8.2% |
| o | 72 | 5.8% |
| 1 | 50 | 4.0% |
| 4 | 48 | 3.8% |
| Other values (8) | 266 |
CITY
Text
Missing
| Distinct | 40 |
|---|---|
| Distinct (%) | 2.7% |
| Missing | 1315 |
| Missing (%) | 46.6% |
| Memory size | 22.2 KiB |
Length
| Max length | 13 |
|---|---|
| Median length | 10 |
| Mean length | 8.167771883 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | NYC |
|---|---|
| 2nd row | Reims |
| 3rd row | Paris |
| 4th row | Pasadena |
| 5th row | San Francisco |
| Value | Count | Frequency (%) |
| san | 307 | 15.3% |
| rafael | 180 | 8.9% |
| nyc | 152 | 7.6% |
| new | 78 | 3.9% |
| francisco | 62 | 3.1% |
| bedford | 61 | 3.0% |
| bergamo | 48 | 2.4% |
| brickhaven | 47 | 2.3% |
| boston | 44 | 2.2% |
| reims | 41 | 2.0% |
| Other values (36) | 993 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 1703 | 13.8% |
| e | 1161 | 9.4% |
| n | 889 | 7.2% |
| r | 692 | 5.6% |
| o | 666 | 5.4% |
| i | 636 | 5.2% |
| l | 563 | 4.6% |
| s | 506 | 4.1% |
| 505 | 4.1% | |
| S | 415 | 3.4% |
| Other values (35) | 4581 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 9495 | |
| Uppercase Letter | 2317 | 18.8% |
| Space Separator | 505 | 4.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 1703 | |
| e | 1161 | |
| n | 889 | |
| r | 692 | 7.3% |
| o | 666 | 7.0% |
| i | 636 | 6.7% |
| l | 563 | 5.9% |
| s | 506 | 5.3% |
| g | 353 | 3.7% |
| d | 260 | 2.7% |
| Other values (14) | 2066 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 415 | |
| B | 350 | |
| N | 285 | |
| R | 260 | |
| C | 242 | |
| Y | 152 | 6.6% |
| P | 99 | 4.3% |
| F | 62 | 2.7% |
| A | 58 | 2.5% |
| V | 51 | 2.2% |
| Other values (10) | 343 |
Space Separator
| Value | Count | Frequency (%) |
| 505 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 11812 | |
| Common | 505 | 4.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 1703 | |
| e | 1161 | 9.8% |
| n | 889 | 7.5% |
| r | 692 | 5.9% |
| o | 666 | 5.6% |
| i | 636 | 5.4% |
| l | 563 | 4.8% |
| s | 506 | 4.3% |
| S | 415 | 3.5% |
| g | 353 | 3.0% |
| Other values (34) | 4228 |
Common
| Value | Count | Frequency (%) |
| 505 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 12317 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 1703 | 13.8% |
| e | 1161 | 9.4% |
| n | 889 | 7.2% |
| r | 692 | 5.6% |
| o | 666 | 5.4% |
| i | 636 | 5.2% |
| l | 563 | 4.6% |
| s | 506 | 4.1% |
| 505 | 4.1% | |
| S | 415 | 3.4% |
| Other values (35) | 4581 |
STATE
Text
Missing
| Distinct | 11 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 1784 |
| Missing (%) | 63.2% |
| Memory size | 22.2 KiB |
Length
| Max length | 13 |
|---|---|
| Median length | 2 |
| Mean length | 2.359961501 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | NY |
|---|---|
| 2nd row | CA |
| 3rd row | CA |
| 4th row | CA |
| 5th row | CA |
| Value | Count | Frequency (%) |
| ca | 402 | |
| ma | 190 | |
| ny | 178 | |
| ct | 61 | 5.6% |
| pa | 54 | 4.9% |
| nh | 34 | 3.1% |
| nv | 29 | 2.7% |
| isle | 26 | 2.4% |
| of | 26 | 2.4% |
| wight | 26 | 2.4% |
| Other values (3) | 65 | 6.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 646 | |
| C | 485 | |
| N | 262 | |
| M | 190 | 7.7% |
| Y | 178 | 7.3% |
| e | 70 | 2.9% |
| T | 61 | 2.5% |
| P | 54 | 2.2% |
| 52 | 2.1% | |
| H | 34 | 1.4% |
| Other values (17) | 420 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 2056 | |
| Lowercase Letter | 344 | 14.0% |
| Space Separator | 52 | 2.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 646 | |
| C | 485 | |
| N | 262 | |
| M | 190 | 9.2% |
| Y | 178 | 8.7% |
| T | 61 | 3.0% |
| P | 54 | 2.6% |
| H | 34 | 1.7% |
| V | 29 | 1.4% |
| I | 26 | 1.3% |
| Other values (4) | 91 | 4.4% |
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 70 | |
| s | 26 | 7.6% |
| l | 26 | 7.6% |
| o | 26 | 7.6% |
| f | 26 | 7.6% |
| i | 26 | 7.6% |
| g | 26 | 7.6% |
| h | 26 | 7.6% |
| t | 26 | 7.6% |
| u | 22 | 6.4% |
| Other values (2) | 44 |
Space Separator
| Value | Count | Frequency (%) |
| 52 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2400 | |
| Common | 52 | 2.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 646 | |
| C | 485 | |
| N | 262 | |
| M | 190 | 7.9% |
| Y | 178 | 7.4% |
| e | 70 | 2.9% |
| T | 61 | 2.5% |
| P | 54 | 2.2% |
| H | 34 | 1.4% |
| V | 29 | 1.2% |
| Other values (16) | 391 |
Common
| Value | Count | Frequency (%) |
| 52 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2452 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 646 | |
| C | 485 | |
| N | 262 | |
| M | 190 | 7.7% |
| Y | 178 | 7.3% |
| e | 70 | 2.9% |
| T | 61 | 2.5% |
| P | 54 | 2.2% |
| 52 | 2.1% | |
| H | 34 | 1.4% |
| Other values (17) | 420 |
POSTALCODE
Text
Missing
| Distinct | 36 |
|---|---|
| Distinct (%) | 2.5% |
| Missing | 1377 |
| Missing (%) | 48.8% |
| Memory size | 22.2 KiB |
Length
| Max length | 8 |
|---|---|
| Median length | 5 |
| Mean length | 5.143153527 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 10022 |
|---|---|
| 2nd row | 51100 |
| 3rd row | 75508 |
| 4th row | 90003 |
| 5th row | 94217 |
| Value | Count | Frequency (%) |
| 97562 | 205 | 13.0% |
| 10022 | 152 | 9.6% |
| 94217 | 89 | 5.6% |
| 50553 | 61 | 3.9% |
| 24100 | 48 | 3.0% |
| 58339 | 47 | 3.0% |
| 51003 | 44 | 2.8% |
| 51100 | 41 | 2.6% |
| 5020 | 40 | 2.5% |
| 42100 | 39 | 2.5% |
| Other values (31) | 814 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1454 | |
| 2 | 1023 | |
| 1 | 976 | |
| 5 | 730 | |
| 7 | 673 | |
| 9 | 539 | 7.2% |
| 4 | 454 | 6.1% |
| 3 | 430 | 5.8% |
| 6 | 392 | 5.3% |
| 8 | 218 | 2.9% |
| Other values (13) | 548 | 7.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 6889 | |
| Uppercase Letter | 351 | 4.7% |
| Space Separator | 134 | 1.8% |
| Dash Punctuation | 63 | 0.8% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 52 | |
| M | 52 | |
| J | 48 | |
| S | 38 | |
| O | 26 | |
| B | 25 | |
| H | 22 | |
| C | 22 | |
| V | 22 | |
| F | 22 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 1454 | |
| 2 | 1023 | |
| 1 | 976 | |
| 5 | 730 | |
| 7 | 673 | |
| 9 | 539 | 7.8% |
| 4 | 454 | 6.6% |
| 3 | 430 | 6.2% |
| 6 | 392 | 5.7% |
| 8 | 218 | 3.2% |
Space Separator
| Value | Count | Frequency (%) |
| 134 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 63 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 7086 | |
| Latin | 351 | 4.7% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 1454 | |
| 2 | 1023 | |
| 1 | 976 | |
| 5 | 730 | |
| 7 | 673 | |
| 9 | 539 | 7.6% |
| 4 | 454 | 6.4% |
| 3 | 430 | 6.1% |
| 6 | 392 | 5.5% |
| 8 | 218 | 3.1% |
| Other values (2) | 197 | 2.8% |
Latin
| Value | Count | Frequency (%) |
| P | 52 | |
| M | 52 | |
| J | 48 | |
| S | 38 | |
| O | 26 | |
| B | 25 | |
| H | 22 | |
| C | 22 | |
| V | 22 | |
| F | 22 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 7437 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 1454 | |
| 2 | 1023 | |
| 1 | 976 | |
| 5 | 730 | |
| 7 | 673 | |
| 9 | 539 | 7.2% |
| 4 | 454 | 6.1% |
| 3 | 430 | 5.8% |
| 6 | 392 | 5.3% |
| 8 | 218 | 2.9% |
| Other values (13) | 548 | 7.4% |
COUNTRY
Text
Missing
| Distinct | 12 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 1315 |
| Missing (%) | 46.6% |
| Memory size | 22.2 KiB |
Length
| Max length | 11 |
|---|---|
| Median length | 3 |
| Mean length | 4.181034483 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | USA |
|---|---|
| 2nd row | France |
| 3rd row | France |
| 4th row | USA |
| 5th row | USA |
| Value | Count | Frequency (%) |
| usa | 969 | |
| italy | 113 | 7.5% |
| france | 81 | 5.4% |
| denmark | 63 | 4.2% |
| austria | 55 | 3.6% |
| canada | 44 | 2.9% |
| sweden | 38 | 2.5% |
| singapore | 36 | 2.4% |
| norway | 32 | 2.1% |
| uk | 26 | 1.7% |
| Other values (2) | 51 | 3.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 1043 | |
| A | 1024 | |
| U | 995 | |
| a | 512 | 8.1% |
| e | 307 | 4.9% |
| n | 288 | 4.6% |
| r | 267 | 4.2% |
| i | 194 | 3.1% |
| t | 168 | 2.7% |
| l | 164 | 2.6% |
| Other values (20) | 1343 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 3472 | |
| Lowercase Letter | 2833 |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 512 | |
| e | 307 | |
| n | 288 | |
| r | 267 | |
| i | 194 | 6.8% |
| t | 168 | 5.9% |
| l | 164 | 5.8% |
| y | 145 | 5.1% |
| m | 88 | 3.1% |
| p | 88 | 3.1% |
| Other values (9) | 612 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 1043 | |
| A | 1024 | |
| U | 995 | |
| I | 113 | 3.3% |
| F | 81 | 2.3% |
| D | 63 | 1.8% |
| C | 44 | 1.3% |
| N | 32 | 0.9% |
| K | 26 | 0.7% |
| P | 26 | 0.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 6305 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| S | 1043 | |
| A | 1024 | |
| U | 995 | |
| a | 512 | 8.1% |
| e | 307 | 4.9% |
| n | 288 | 4.6% |
| r | 267 | 4.2% |
| i | 194 | 3.1% |
| t | 168 | 2.7% |
| l | 164 | 2.6% |
| Other values (20) | 1343 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 6305 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| S | 1043 | |
| A | 1024 | |
| U | 995 | |
| a | 512 | 8.1% |
| e | 307 | 4.9% |
| n | 288 | 4.6% |
| r | 267 | 4.2% |
| i | 194 | 3.1% |
| t | 168 | 2.7% |
| l | 164 | 2.6% |
| Other values (20) | 1343 |
TERRITORY
Text
Missing
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 2328 |
| Missing (%) | 82.5% |
| Memory size | 22.2 KiB |
Length
| Max length | 5 |
|---|---|
| Median length | 4 |
| Mean length | 4.052525253 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | EMEA |
|---|---|
| 2nd row | EMEA |
| 3rd row | EMEA |
| 4th row | EMEA |
| 5th row | EMEA |
| Value | Count | Frequency (%) |
| emea | 433 | |
| apac | 36 | 7.3% |
| japan | 26 | 5.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 866 | |
| A | 505 | |
| M | 433 | |
| a | 52 | 2.6% |
| P | 36 | 1.8% |
| C | 36 | 1.8% |
| J | 26 | 1.3% |
| p | 26 | 1.3% |
| n | 26 | 1.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1902 | |
| Lowercase Letter | 104 | 5.2% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 866 | |
| A | 505 | |
| M | 433 | |
| P | 36 | 1.9% |
| C | 36 | 1.9% |
| J | 26 | 1.4% |
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 52 | |
| p | 26 | |
| n | 26 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2006 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 866 | |
| A | 505 | |
| M | 433 | |
| a | 52 | 2.6% |
| P | 36 | 1.8% |
| C | 36 | 1.8% |
| J | 26 | 1.3% |
| p | 26 | 1.3% |
| n | 26 | 1.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2006 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 866 | |
| A | 505 | |
| M | 433 | |
| a | 52 | 2.6% |
| P | 36 | 1.8% |
| C | 36 | 1.8% |
| J | 26 | 1.3% |
| p | 26 | 1.3% |
| n | 26 | 1.3% |
CONTACTLASTNAME
Text
Missing
| Distinct | 37 |
|---|---|
| Distinct (%) | 2.5% |
| Missing | 1315 |
| Missing (%) | 46.6% |
| Memory size | 22.2 KiB |
Length
| Max length | 10 |
|---|---|
| Median length | 9 |
| Mean length | 6.00464191 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Yu |
|---|---|
| 2nd row | Henriot |
| 3rd row | Da Cunha |
| 4th row | Young |
| 5th row | Brown |
| Value | Count | Frequency (%) |
| nelson | 204 | 13.4% |
| young | 115 | 7.5% |
| frick | 91 | 6.0% |
| yu | 80 | 5.2% |
| hernandez | 70 | 4.6% |
| brown | 62 | 4.1% |
| king | 54 | 3.5% |
| rovelli | 48 | 3.1% |
| henriot | 41 | 2.7% |
| pipps | 40 | 2.6% |
| Other values (28) | 723 |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 1104 | 12.2% |
| o | 917 | 10.1% |
| e | 910 | 10.0% |
| r | 691 | 7.6% |
| s | 568 | 6.3% |
| i | 560 | 6.2% |
| l | 390 | 4.3% |
| u | 363 | 4.0% |
| a | 347 | 3.8% |
| t | 237 | 2.6% |
| Other values (31) | 2968 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 7507 | |
| Uppercase Letter | 1528 | 16.9% |
| Space Separator | 20 | 0.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 1104 | |
| o | 917 | |
| e | 910 | |
| r | 691 | |
| s | 568 | 7.6% |
| i | 560 | 7.5% |
| l | 390 | 5.2% |
| u | 363 | 4.8% |
| a | 347 | 4.6% |
| t | 237 | 3.2% |
| Other values (14) | 1420 |
Uppercase Letter
| Value | Count | Frequency (%) |
| Y | 221 | |
| N | 204 | |
| B | 161 | |
| H | 145 | |
| F | 131 | |
| T | 129 | |
| M | 92 | 6.0% |
| P | 76 | 5.0% |
| R | 68 | 4.5% |
| K | 64 | 4.2% |
| Other values (6) | 237 |
Space Separator
| Value | Count | Frequency (%) |
| 20 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 9035 | |
| Common | 20 | 0.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| n | 1104 | 12.2% |
| o | 917 | 10.1% |
| e | 910 | 10.1% |
| r | 691 | 7.6% |
| s | 568 | 6.3% |
| i | 560 | 6.2% |
| l | 390 | 4.3% |
| u | 363 | 4.0% |
| a | 347 | 3.8% |
| t | 237 | 2.6% |
| Other values (30) | 2948 |
Common
| Value | Count | Frequency (%) |
| 20 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 9055 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| n | 1104 | 12.2% |
| o | 917 | 10.1% |
| e | 910 | 10.0% |
| r | 691 | 7.6% |
| s | 568 | 6.3% |
| i | 560 | 6.2% |
| l | 390 | 4.3% |
| u | 363 | 4.0% |
| a | 347 | 3.8% |
| t | 237 | 2.6% |
| Other values (31) | 2968 |
CONTACTFIRSTNAME
Text
Missing
| Distinct | 37 |
|---|---|
| Distinct (%) | 2.5% |
| Missing | 1315 |
| Missing (%) | 46.6% |
| Memory size | 22.2 KiB |
Length
| Max length | 9 |
|---|---|
| Median length | 8 |
| Mean length | 5.483421751 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Kwai |
|---|---|
| 2nd row | Paul |
| 3rd row | Daniel |
| 4th row | Julie |
| 5th row | Julie |
| Value | Count | Frequency (%) |
| valarie | 257 | 16.7% |
| julie | 117 | 7.6% |
| sue | 84 | 5.4% |
| juri | 60 | 3.9% |
| maria | 58 | 3.8% |
| kwai | 49 | 3.2% |
| jeff | 48 | 3.1% |
| giovanni | 48 | 3.1% |
| kyung | 42 | 2.7% |
| paul | 41 | 2.7% |
| Other values (28) | 739 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 1142 | |
| e | 1073 | |
| i | 953 | |
| l | 766 | 9.3% |
| r | 532 | 6.4% |
| n | 458 | 5.5% |
| u | 398 | 4.8% |
| o | 323 | 3.9% |
| J | 315 | 3.8% |
| V | 283 | 3.4% |
| Other values (26) | 2026 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 6691 | |
| Uppercase Letter | 1543 | 18.7% |
| Space Separator | 35 | 0.4% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 1142 | |
| e | 1073 | |
| i | 953 | |
| l | 766 | |
| r | 532 | |
| n | 458 | |
| u | 398 | 5.9% |
| o | 323 | 4.8% |
| t | 229 | 3.4% |
| g | 132 | 2.0% |
| Other values (10) | 685 |
Uppercase Letter
| Value | Count | Frequency (%) |
| J | 315 | |
| V | 283 | |
| M | 164 | |
| S | 123 | 8.0% |
| K | 101 | 6.5% |
| P | 94 | 6.1% |
| W | 92 | 6.0% |
| G | 88 | 5.7% |
| A | 70 | 4.5% |
| C | 60 | 3.9% |
| Other values (5) | 153 |
Space Separator
| Value | Count | Frequency (%) |
| 35 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 8234 | |
| Common | 35 | 0.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 1142 | |
| e | 1073 | |
| i | 953 | |
| l | 766 | 9.3% |
| r | 532 | 6.5% |
| n | 458 | 5.6% |
| u | 398 | 4.8% |
| o | 323 | 3.9% |
| J | 315 | 3.8% |
| V | 283 | 3.4% |
| Other values (25) | 1991 |
Common
| Value | Count | Frequency (%) |
| 35 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 8269 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 1142 | |
| e | 1073 | |
| i | 953 | |
| l | 766 | 9.3% |
| r | 532 | 6.4% |
| n | 458 | 5.5% |
| u | 398 | 4.8% |
| o | 323 | 3.9% |
| J | 315 | 3.8% |
| V | 283 | 3.4% |
| Other values (26) | 2026 |
DEALSIZE
Text
Missing
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 1315 |
| Missing (%) | 46.6% |
| Memory size | 22.2 KiB |
Length
| Max length | 6 |
|---|---|
| Median length | 5 |
| Mean length | 5.49403183 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Small |
|---|---|
| 2nd row | Small |
| 3rd row | Medium |
| 4th row | Medium |
| 5th row | Medium |
| Value | Count | Frequency (%) |
| medium | 745 | |
| small | 673 | |
| large | 90 | 6.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| m | 1418 | |
| l | 1346 | |
| e | 835 | |
| a | 763 | |
| i | 745 | |
| d | 745 | |
| M | 745 | |
| u | 745 | |
| S | 673 | |
| L | 90 | 1.1% |
| Other values (2) | 180 | 2.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 6777 | |
| Uppercase Letter | 1508 | 18.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| m | 1418 | |
| l | 1346 | |
| e | 835 | |
| a | 763 | |
| i | 745 | |
| d | 745 | |
| u | 745 | |
| r | 90 | 1.3% |
| g | 90 | 1.3% |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 745 | |
| S | 673 | |
| L | 90 | 6.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 8285 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| m | 1418 | |
| l | 1346 | |
| e | 835 | |
| a | 763 | |
| i | 745 | |
| d | 745 | |
| M | 745 | |
| u | 745 | |
| S | 673 | |
| L | 90 | 1.1% |
| Other values (2) | 180 | 2.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 8285 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| m | 1418 | |
| l | 1346 | |
| e | 835 | |
| a | 763 | |
| i | 745 | |
| d | 745 | |
| M | 745 | |
| u | 745 | |
| S | 673 | |
| L | 90 | 1.1% |
| Other values (2) | 180 | 2.2% |